2016-05-18 - 26887.100 - Enhacement - Redesign of Delivery Split Report OSA410 #SalesDistribution

Enhancement

26887.100 - Redesign of Delivery Split Report OSA410

Purpose

Need to add requested Delivery date to OSA410 BW BEx Queries.

Admin Info

Purpose
 Need to add requested Delivery date to OSA410 BW BEx Queries
Requested By
 Jayne Palfreman
Spec Created By
 Naveen Gadde
Spec Created Date
 05/18/2016
Spec QA by
 Uday Kumar P
Objects
 ZMP_OOCON_Q006 - Global
ZEA_OOCON_Q006 - Emerging Americas
ZEM_OOCON_Q006 - EMEA
ZJA_OOCON_Q006 - Japan
ZEJ_OOCON_Q006 - Emerging JAPAC
Document Status
 Complete

Estimates

SNo
 Activity
 Estimation in Hours
1
 Research
 02
2
 Documentation
 02
3
 Development/ Config
 04
4
 Unit test in DEV
 02
5
 Unit test in QUA
 04
6
 Other activity
 02

TOTAL
 16

References

Prior Tickets

None

Documents

None

Spec Changes

SNo
 Change Details
 Requested By
 Requested On
 Notes if any

























Functional Requirement

Purpose/WHY:

Email from Daniel Brennan on 05/18/2016:
As discussed, to support changes to report OSA410, we will need the data source below to include the Requested Delivery Date from the sales order header. In ECC this would be field VBAK-VDATU.

In Scope:

Changes to all OSA410 Global & Regional BEx queries is required.

Out of Scope:

The field VBAK-VDATU is not getting updated to any other of the sources in BW, so it is not possible to update the source with VBAK-VDATU for now.

Solution Summary

Since the field requested delivery date in sales order header level is not getting updated to any of the sources in BW, It is requested to add Requested delivery date from the Sales order Item level.
As requested delivery date at item level is readily available in BW Open order Sources(OOCON), the BEx queries needs to be enhanced with the field.

Test Plan

SNo
 Test Scenario
 Expected Results
1
 Check if the requested delivery date is added to all the Regional & Global BEx Queries.
 All the Regional & Global regional BEx Queries should be updated with Requested delivery date.
2
 Check if all the changes are collected into the transport request.
 All the changes should be collected into the transport request.

Solution Details

1. Need to add Requested delivery date(0AF_RQDATE) to all OSA410 Global & Regional BEx Queries:
ZMP_OOCON_Q006 - Global
ZEA_OOCON_Q006 - Emerging Americas
ZEM_OOCON_Q006 - EMEA
ZJA_OOCON_Q006 - Japan
ZEJ_OOCON_Q006 - Emerging JAPAC

2. Need to validate the changes in all the Global & Regional BEx Queries in BPD & BPQ.

Issues

None